UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sppXQcIF6/ZjNWuWSh5F0nsymeihWYkfk6aKMRHjbvM='
WHERE
key_id = 'bff60c6b70d925773c3f85a188d4b929ffa148ec2908b419ebf14ea732f72a87'
AND (
token = 'sppXQcIF6/ZjNWuWSh5F0nsymeihWYkfk6aKMRHjbvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)