UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TRvwQPb+phTi4fChZBYHLWjBQLiunsaMnX62iyGMvRY='
WHERE
key_id = 'fe802da7acdb5177c757e37b00ab604f04118a2c447da7f2a0a1c9fcc543013b'
AND (
token = 'TRvwQPb+phTi4fChZBYHLWjBQLiunsaMnX62iyGMvRY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)