UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w9b6U0BwpS+q4QTeGTJXeYvTfb64hASLBpLDOVirkCY='
WHERE
key_id = 'be1b2e46fb4fb740278e4cb861b2b54d67ebb79748a7b636060734b22ab86eb6'
AND (
token = 'w9b6U0BwpS+q4QTeGTJXeYvTfb64hASLBpLDOVirkCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)