UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CHUqFS/LS7O9aVqXcBoOmG3jVKkBCjeXDdNUbRqMi2w='
WHERE
key_id = '7d1fd3b38bacfc2b067f9a84924c9e134faf7e2cbdd3870e3fd1fc296d1cd3ee'
AND (
token = 'CHUqFS/LS7O9aVqXcBoOmG3jVKkBCjeXDdNUbRqMi2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)