UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ebv0Mp9hZpipV7jrqGKCe3edXLjyN8TSs7yByTOoog='
WHERE
key_id = 'a1a232ee1bacdc5c015da99884b66f1a2fe6a8b25c6b8b060b0a9edb051504d3'
AND (
token = '0ebv0Mp9hZpipV7jrqGKCe3edXLjyN8TSs7yByTOoog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)