UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fX845j+Tq/A64ARPHCXiOP2EjCpLTbIc/hsBktYeYN4='
WHERE
key_id = 'edccb6f711b9a156a56538041649341c5be138693b865e3086e5d47aa07082a8'
AND (
token = 'fX845j+Tq/A64ARPHCXiOP2EjCpLTbIc/hsBktYeYN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)