UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lYXikaGJC3oHiqAyk6t+pqnHWyazF59XfyMKQTAbgGU='
WHERE
key_id = 'a7707b4d34abc651f76cd58fbb2b7e27a7729c51007de2455b6105e7953ab223'
AND (
token = 'lYXikaGJC3oHiqAyk6t+pqnHWyazF59XfyMKQTAbgGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)