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