UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7erno4SbAG2wCiMiDwnXgobEgIaxAI+GV30+N/y1Ccs='
WHERE
key_id = 'f04664851b4c8fb3e5fb05bedcab3a87cb17160dea320b93643321c3cafde1e7'
AND (
token = '7erno4SbAG2wCiMiDwnXgobEgIaxAI+GV30+N/y1Ccs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)