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