UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NKVBSe4ipwR57x2UUDm2r3vHUCJJSDje2dRIuy4DLFw='
WHERE
key_id = 'a8b5d99d9c45420cc6755d0608fe05e18ace7d202236a2af572330da874cf520'
AND (
token = 'NKVBSe4ipwR57x2UUDm2r3vHUCJJSDje2dRIuy4DLFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)