UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qnp+fqlLo8J5dI6AIAq2HCrRM/JVpVH/h5YpatFTkNU='
WHERE
key_id = '495ce4bfe668698e70258303ef9bb234dbded167400332b8d82d051b34fc30eb'
AND (
token = 'Qnp+fqlLo8J5dI6AIAq2HCrRM/JVpVH/h5YpatFTkNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)