UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXk1CIjTOwNlBM9tnvcRiY7GYLaWVGpnwDoNXV9Y7Vc='
WHERE
key_id = '4c2e9e1ecefba63307a8ee29be07b250d040eb39f9a380f9df8d503b10bdfc22'
AND (
token = 'XXk1CIjTOwNlBM9tnvcRiY7GYLaWVGpnwDoNXV9Y7Vc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)