UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HFEG4qUSKbaOi3965/vmnix/sg1keJmzgKmXf3LrI04='
WHERE
key_id = 'ca03b8597af71b76c61887270b7d382168ea4508c98a2291b6b7d276d16bee3a'
AND (
token = 'HFEG4qUSKbaOi3965/vmnix/sg1keJmzgKmXf3LrI04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)