UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6CLU1s9B1Yq11zElOQNgE4ouZ9IhwDh/7u+/4xxkC3k=' 
WHERE 
  key_id = 'fce27bf192d982e05e4e9713217dfa18950e0a5a03a43e6e49064c159d66f202' 
  AND (
    token = '6CLU1s9B1Yq11zElOQNgE4ouZ9IhwDh/7u+/4xxkC3k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022