UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'a7UPcnv7yT1By8OoQP9QeLgSpOTGVdLtyp8ZJBSGPdg=' 
WHERE 
  key_id = '2749f64046b37a07bde9d59ed3159437a4ea9bd6c586db862f1805b2a696c052' 
  AND (
    token = 'a7UPcnv7yT1By8OoQP9QeLgSpOTGVdLtyp8ZJBSGPdg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021