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