UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8rtJeGPndjFhwm1tdv2gEm8Vc4EZCQFWiINdZEuuweo='
WHERE
key_id = '1c31ed5750dd4480315a5104fc2ed2f04f072cd0f242427f0e6c2663c71362ec'
AND (
token = '8rtJeGPndjFhwm1tdv2gEm8Vc4EZCQFWiINdZEuuweo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)