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