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