UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+Jb30AQLPRDCcnlKSUTdfNtLCnxVtLCkUPuxf91iws4='
WHERE
key_id = 'd1b7b04ed7e5a6ad14abdd14940a712d4a6f8ef9bf8b81d3eae4fb6b2fac53f6'
AND (
token = '+Jb30AQLPRDCcnlKSUTdfNtLCnxVtLCkUPuxf91iws4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)