UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Gl8a3frXVNcJGgV1od6+7cBQj8cF3yE4G71Jc3MK6g='
WHERE
key_id = 'c71f1c321103972e515a64b9e5bff1b62a567ae00b79ffbb84d0ef3c29d818d0'
AND (
token = '/Gl8a3frXVNcJGgV1od6+7cBQj8cF3yE4G71Jc3MK6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)