UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o0+6k6cAj6me6RwuFlhy/9NYjZiJ/bRmmxeN1aTIZ08='
WHERE
key_id = '28a0d2c54f211d2f4b9fcb2ba2a73b05955dd4dd1bc4f43361f9f94fe8a2a793'
AND (
token = 'o0+6k6cAj6me6RwuFlhy/9NYjZiJ/bRmmxeN1aTIZ08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)