UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KZXDLYW4n1rz7EJ5fTmnn1eSN+V85CyIs6StFfnjU/U='
WHERE
key_id = 'a78a8ba97f22dacd31d6dfa39c2672b4dc5a10b9e93c210c8f4e1a5d1502f8e3'
AND (
token = 'KZXDLYW4n1rz7EJ5fTmnn1eSN+V85CyIs6StFfnjU/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)