UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBSMZjITuQLVsc83SBnffTAM3vkxkPc7nwCp5q9yFDc='
WHERE
key_id = '1aaf28d78b99fdcfb1e7b70488908ae62a3fab717417d366dd8e01d617eab46e'
AND (
token = 'pBSMZjITuQLVsc83SBnffTAM3vkxkPc7nwCp5q9yFDc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)