UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U/puqgrXXXs4GrEo8zSNk6J1QW4Bgn0n5SCntyhB5Ko='
WHERE
key_id = '16d5704c731927f589d6fad3c23f064d5d64b70520fc5fc272fd8261878a4943'
AND (
token = 'U/puqgrXXXs4GrEo8zSNk6J1QW4Bgn0n5SCntyhB5Ko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)