UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ekYaw1LhfyVMFsuUMmoNWbmdTAxA1Dm9A63SiXSWcc='
WHERE
key_id = '6a81f547e927f64490806fb90308e33a53c33452f72a69afd17c0663bb0f0074'
AND (
token = '/ekYaw1LhfyVMFsuUMmoNWbmdTAxA1Dm9A63SiXSWcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)