UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'X9Wk3xze9GTMDvuazurRUVf90Xt+cnWjQbDPO0j2Znw=' 
WHERE 
  key_id = '6a8ba4172448098d6ae716775f6db352293887b2e1e3d31de8a604fb7770492d' 
  AND (
    token = 'X9Wk3xze9GTMDvuazurRUVf90Xt+cnWjQbDPO0j2Znw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047