UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CJ1rcDB8uTEOdG8/+2ZIQ2bf+3EoP4UoAgEUJ6vZ5jg='
WHERE
key_id = 'ae3c9ba14f7a781ce910e67324a072ab4495f7bc97c5bdf066944e223a0dd647'
AND (
token = 'CJ1rcDB8uTEOdG8/+2ZIQ2bf+3EoP4UoAgEUJ6vZ5jg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)