UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Cn1Zc5+XYusCoHe2FsV5iPlNymE5v6tfgMOhgn77gv0=' 
WHERE 
  key_id = '5fcb19179747278296c4c6d5e75f79e009e0647490602a76c8e76c89515cf4fb' 
  AND (
    token = 'Cn1Zc5+XYusCoHe2FsV5iPlNymE5v6tfgMOhgn77gv0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00056