UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OlFxRuf2R3ZhhF5mn/POCHa26E0olOm2XnM8NyZt/l4='
WHERE
key_id = 'f4e76103c7f47e83cdb01120b851e2036a793ede74ca5b12f54291e3a6aeef98'
AND (
token = 'OlFxRuf2R3ZhhF5mn/POCHa26E0olOm2XnM8NyZt/l4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)