UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HI1NJeo4+JhvGJEZfRt3oZF4phkBdiT4W7R07HioewA='
WHERE
key_id = 'ad5354a0545733b7073c6139a44b24cd0620cc6b051dfabc1545d71e1558f0f0'
AND (
token = 'HI1NJeo4+JhvGJEZfRt3oZF4phkBdiT4W7R07HioewA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)