UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IcC/l47ILvsvVui60YulL/9eFlhiRa9xm23EzCNl5CU='
WHERE
key_id = '705c799ff09f3e6e90ad7a51192b6ed57d0b4fb50145d4110f4fba417517de8a'
AND (
token = 'IcC/l47ILvsvVui60YulL/9eFlhiRa9xm23EzCNl5CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)